/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost
 Source Database       : itchao-member

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : utf-8

 Date: 05/05/2019 15:57:16 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `member`
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` bigint(13) NOT NULL,
  `usernmae` varchar(20) DEFAULT NULL,
  `password` varchar(20) DEFAULT NULL,
  `nick_name` varchar(20) DEFAULT NULL,
  `mobile` varchar(11) DEFAULT NULL,
  `email` varchar(20) DEFAULT NULL,
  `gender` tinyint(1) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `head_image` varchar(100) DEFAULT NULL,
  `create_at` bigint(13) DEFAULT NULL,
  `update_at` bigint(13) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `member`
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES ('10001', '靳超', '123', '北岩', '18516908635', '370696614@qq.com', '1', '陕西省洋县', '1', '正常', 'http://www.baidu.com', '1556542483236', '1556542483236');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
